www.gusucode.com > XerCMS 携云PHP企业建站程序 v2015PHP源码程序 > XerCMS 携云PHP企业建站程序 v2015/XerCMS_v20150724/XerCMS_v20150724/XerCMS/Services/admin/libs/XerCMS_member.php

    <?php
/**
 * @name     XERCMS
 * @author   Arno <XerCMS@163.com> [QQ:1328013]
 * @version  1.0.0
 * @link     http://www.XerCMS.com
 */
  
!defined('XERCMS') && exit('Access Denied');

function modelbox($m) { 
	global $model;$ret = '';
	foreach($model as $k=>$v) {
		if(arrayfind($m,$k)) {
			$ret .= '<input type="checkbox" name="model[]" checked="checked" value="'.$k.'">&nbsp;'.$v['title'].'&nbsp;&nbsp;';
		} else $ret .= '<input type="checkbox" name="model[]" value="'.$k.'">&nbsp;'.$v['title'].'&nbsp;&nbsp;';
  	}
  	return $ret;
}

function upgradeselect($id,$option) {
	$ret = '<select name="data[2]"><option value="">无需升级</option>';
	foreach($option as $key=>$val) {
		$ret .= '<option value="'.$val['id'].'" '.($val['id'] == $id ? ' selected ' : '').'>'.($val['top'] != 0 ?  '&nbsp;&nbsp;--&nbsp;&nbsp;' : '').$val['name'].'</option>';
	}
	return $ret.'</select>';
}

function upgradecredit($id,$option) {
	$ret = '<select name="data[0]">';//print_r($option);exit($id.'/');
	foreach($option as $key=>$val) {
		if($val['state']) {
			$ret .= '<option value="'.$key.'" '.($key == $id ? ' selected ' : '').'>'.$val['title'].'</option>';
		}
  	}
  	return $ret.'</select>';
}



function readclass($sid = 0,$level = 0) {
  	$res = DB::query('SELECT * FROM xercms_member_group WHERE top = '.$sid);
  	$class = '';
  	while ($res && $data = DB::fetch($res)) {
    		$class[$data['id']]['id'] = $data['id'];
		$class[$data['id']]['top'] = $data['top'];
    		$class[$data['id']]['name'] = $data['name'];
    		$class[$data['id']]['level'] = $level;
		$two = DB::query('SELECT count(*) FROM xercms_member_group WHERE top = '.$data['id']);
		$total = DB::fetch($two);
    		$class[$data['id']]['count'] = $total['count(*)'];  
		if($total['count(*)'] > 0 ) {
			$class = $class + readclass($data['id'],($level+1));
		}
  	}
  	return $class;
}

function topusergroup($id) {
	$res = DB::query('SELECT * FROM xercms_member_group WHERE id = '.$id);
  	$class = '';
	while ($res && $data = DB::fetch($res)) {
		$class[] = $data['id'];
		$class[] = $data['top'];
		if($data['top'] != 0) {
	    		$class = array_merge($class,topclass($data['top']));
		}
  	}
  	return $class;
}

function membergroupdata($id) {
	if($id == 0) {
		return array('id'=>'','name'=>'','top'=>0,'note'=>'');
  	}
  	$res = DB::query('SELECT * FROM xercms_member_group WHERE id = \''.$id.'\'');
  	$usergroup = array();
  	$res && $usergroup = DB::fetch($res);
  	return $usergroup; 
}

function membermaillist($page) {
	return DB::data('select * from xercms_member_mail order by `time` desc limit '.(($page - 1)*30).',30'); 
}

function membergrouplist() {
  	$res = DB::query('SELECT * FROM xercms_member_group WHERE top = \'0\'');
  	$usergroup = array();
  	while($res && $temp = DB::fetch($res)) {
    		if(isset($temp['name']) && !empty($temp['name'])) {
			$usergroup[] = $temp;
	  		$res2 = DB::query('SELECT * FROM xercms_member_group WHERE top = \''.$temp['id'].'\'');
	 		while($res2 && $data = DB::fetch($res2)) {
				$usergroup[] = $data;
	  		}
		}
  	}
  	return $usergroup; 
}

function membergroupdel($id) {
	$res = DB::query('SELECT count(*) FROM xercms_member_group WHERE top = \''.$id.'\'');
	if($res) { 
		$total = DB::fetch($res);
		if($total['count(*)'] == 0) {
			$res = DB::query('DELETE FROM xercms_member_group WHERE id = \''.$id.'\'');
		}
	}
}

function membergroupupdate($id,$name,$note,$attr,$top) {
	$res = DB::query('UPDATE xercms_member_group SET name = \''.$name.'\',note = \''.$note.'\',attr = \''.$attr.'\',top = \''.$top.'\' WHERE id = \''.$id.'\'');
}

function membergroupadd($name,$top) {
	$res = DB::query('INSERT INTO xercms_member_group VALUES (null,\''.$name.'\',\'\',\''.$top.'\',\'0\')');
}

function memberdata($id) {
	if(empty($id)) {
		return array('uid'=>'','password'=>'','membername'=>'','level'=>$level);
  	}
  	$res = DB::query('SELECT * FROM xercms_member m left join xercms_member_credits c on c.uid = m.uid WHERE m.uid = \''.$id.'\'');
  	$member = array();
  	$res && $member = DB::fetch($res);
  	return $member; 
}

function memberlist($page,$type = '') {
	switch($type) {
		case 'moderators':
			$admin = 'p.`group` in ('.implode(',',$G['moderatorgroup']).')';
		break;
    		case 'admin':
	  		$admin = 'p.`group` in ('.implode(',',$G['admingroup']).')';
		break;	
		default:
			$admin = array();
			foreach($G['moderatorgroup'] as $k=>$v) {
				if(in_array($v,$admin) === false) {
					$admin[] = $v;
				}
	  		}
	  		foreach($G['admingroup'] as $k=>$v) {
	    			if(in_array($v,$admin) === false) {
					$admin[] = $v;
				}
	  		}  
	  		$admin = 'p.`group` not in ('.implode(',',$admin).') and p.uid not in ('.implode(',',$G['superadmin']).')'; 
		break;
  	}
  	$res = DB::query('SELECT * FROM xercms_member m,xercms_member_profile p,xercms_member_session s WHERE s.uid = m.uid AND p.uid = m.uid and '.$admin.' LIMIT '.($page*20).',20');
  	$member = array();
  	while($res && $temp = DB::fetch($res)) {
    		if(isset($temp['name']) && !empty($temp['name'])) {
			$member[] = $temp;
		}
  	}
  	return $member; 
}



function memberdel($id) {
	$res = DB::query('DELETE FROM xercms_member WHERE uid = \''.$id.'\'');
}

function memberupdate($id,$name,$pass) {
	if($_SESSION == $id) {
		$res = DB::query('UPDATE xercms_member SET password = \''.md5($pass).'\' WHERE uid = \''.$id.'\'');
	}
}

function memberadd($name,$pass,$level) {
	$res = DB::query('INSERT INTO xercms_member VALUES (NULL,\''.$name.'\',\''.md5($pass).'\',\''.$level.'\',\''.X::$G['ip'].'\',\''.X::$G['time'].'\')');
  	$id = DB::lastid();
  	DB::query('INSERT INTO xercms_member_credits VALUES ('.$id.',\'0\',\'0\',\'0\',\'0\',\'0\',\'0\')');
  	DB::query('INSERT INTO xercms_member_profile VALUES ('.$id.',\'\',\'0\',\'\',\'\',\''.X::$G['time'].'\',\'\',\'\',\'0\',\'\',\'\',\'\')');
}
?>